Setting up Custom Fields in Taguchi

Last Updated: 17/4/2024     Tags: database, recipients, custom, field, personalization
  • Switch Version
  • V5
  • V4

"Custom fields" are customised data fields that you can use to tailor your campaigns to individual recipients. They are typically created when you have specific data requirements that are not covered by the standard fields provided by Taguchi. These fields can be used to personalise content and segment your campaigns based on recipientโ€™s information, providing a more personalised and relevant communication.

Before introducing new custom fields via an import into a subscriber list, you will need to create these custom fields in the Custom Field area of Taguchi.

To create and manage custom fields, you must have Database Permissions. Refer to this link on Different User types and Role privileges

Step 1: Creating custom fields

  • Go to Settings > Custom Fields
  • To create a new custom field, click on the green Add new field button

Custom field settings

Step 2: Setting up the Custom Field

  • The Custom Field Setup is then displayed. There are two types of custom fields, static type and calculated type.
  • First, input values as following:
    • Field name โ€“ the name of the custom field
    • Field type
      • Subscriber - allows you to store and manage information related to individual subscribers. This could include their contact details, preferences
      • Purchase - used to capture information related to a specific purchase made by a subscriber. It might include details such as the order number, purchase date, or the total amount spent.
      • Product - used to store information about individual products or items. This could include the product name or type.
      • Product Line Item - used to capture data related to individual items within a purchase. It can include details like the product name, quantity, price.
      • Visit - used to store data associated with a subscriber's visit to a website or a physical store. This might include the visit date, duration, or the pages visited.
      • Subscriber Event - used to track specific events or interactions initiated by a subscriber. This could include event names, timestamps, or details about the events.
      • Page - used to capture data related to specific web pages. This might include the page title or an URL.
      • Partition - used to categorise units that facilitate data segmentation and organization. This might include customized groupings of subscribers based on their purchase behavior, geographical location, or preferences field types
  • Group name โ€“ to categorise and easily locate custom fields in related categories on subscriber profiles. This feature is primarily for user interface clarity and doesn't affect the functionality or values of the fields. For instance, assigning the Group name Security Awareness will gather all associated custom fields in the customer profile and target expression for easier management and access. custom fiels Security awareness custom fiels Security awareness2

  • Description โ€“ a brief description on what the the custom field is and used for. (e.g. the type and format of values stored in the custom field) This feature is primarily for user interface clarity and doesn't affect the functionality or values of the fields, and is visible in the Customer profile as well as target expression. Example shown as below.

    custom field setting up

  • Calculation type - There are two types of Custom fields, Static and Calculated. Static Custom Fields store predefined information with enforced validation rules (regex) and optional input, while Calculated Custom Fields require configuration of target expressions, rules, and have periodic updates based on criteria, clearing or replacing values as needed.

    • Static custom field - stores specific, predefined information that have validation rules enforced through a regulated expression (regex).This is optional and can be left blank.
      Below is an example of a Validation regex pattern for a custom field representing a date of birth in the "YYYY-MM-DD" format: ^\d{4}-\d{2}-\d{2}$

    custom field setting up

    This simplified pattern breaks down as follows:

    ^ and $: Indicates the start and end of the string.

    \d{4}: Represents the year portion and expects exactly four digits.
    \d{2}: Represents the month and day portions. Each \d{2} expects exactly two digits.
        -: Expects a hyphen "-" between the year, month, and day.
    

    Refer to this article on POSIX Regular Expression Operators which could assist you in perform various matching operations using regular expressions. (regex)

    • Calculated custom field

    To configure a calculated custom field, you'll need to input the following parameters:

    • Target Expressions: specific criteria or conditions that data must meet to be considered valid for the custom field. For example, a target expression might be for subscribers in a subscriber list that have not made any purchases in the last two weeks.

      Refer to this link to find out target expression references! calculates custom field

    • Rules: to define how the custom field calculates or derives its values based on the target expressions. If you would like to find out how to create an expression rule from scratch, you may contact taguchi Support.
    • Trigger Interval: determines how frequently the custom field updates its values. Choose "Once" for a one-time calculation or "Hourly" for updates every hour.
    • Clear Value from Subscribers Not Matching: removes or clears the custom field value for subscribers whose data does not meet the target expression criteria when recalculated
    • Replace Previous Value for Subscribers Matching: replaces the previous custom field value for subscribers whose data matches the target expression criteria whenever recalculated

    calculates custom field second

Custom Field Statistics

  • Provides a snapshot of subscriber data, including valid and invalid field values, unique value counts, common valid and invalid values, and the timestamp of the last update.

calculates custom field second

Manage Custom fields

  • Once you click Save you will return to the Custom Fields page. Here you can view and manage all your custom fields.
  • To manage a custom field, click on the gear icon located at the end of the row. From here you can delete or archive the field.
    • Delete - removes custom field from this page, but does not remove custom fields (and values) from subscriber profiles.
    • Archive - removes custom field from this page, but does not remove custom fields from subscriber profiles. Please contact Taguchi Support if you would like to un-archive a custom field.

Review Custom Field

Step 3: Bulk creation and update of Custom Fields

  • Custom fields can be uploaded or downloaded in bulk using the upload or download button

Uploading custom fields in bulk

  1. To bulk create custom fields, start off by creating a CSV file containing the following column headers (please note headers must be formatted exactly as below):

    • Group Name
    • Field Type
    • Field Name
    • Description

CSV dummy example

  1. Just like the steps in creating a single custom field, input a value for the above headers. Each row represents a different custom field.
  2. Once you have updated the file and saved as a CSV, click the upload button in the Custom Fields page.

Upload Button

Downloading custom fields in bulk

  1. To download custom fields in bulk, click on the download button in the Custom Fields page.

Download Button

  1. A CSV file will automatically be downloaded to your computer.
  2. In addition to using this file for your own auditing purposes, this file can be used to make bulk changes to existing custom fields.
  3. It is important to note that only the group name and description can be updated. The field name and field type cannot be changed.

Reviewing Custom fields

To check if the custom field and its value has been applied successfully, you could check a relevant subscriber's profile or alternatively you can export the subscriber list and check the exported file to see if the new custom field and value has been appended to the relevant subscriber's data.

Custom Field In Profile

If you have additional questions or require further assistance regarding Custom Fields, do not hesitate to reach out to Taguchi Support